<test>
    <settings>
        <output_format_orc_string_as_string>1</output_format_orc_string_as_string>
        <input_format_orc_row_batch_size>10000</input_format_orc_row_batch_size>
    </settings>

    <create_query>
        create table test_orc_fpd
        (
            a Nullable(Int64),
            b Nullable(String)
        ) Engine=File(ORC)
    </create_query>

    <fill_query>
        insert into test_orc_fpd select number as a, cast(number as String) as b from numbers(10000000)
    </fill_query>
   
    <drop_query>DROP TABLE IF EXISTS test_orc_fpd</drop_query>

    <!-- Test range filter push down to ORC -->
    <query>select a % 10, length(b) % 10, count(1) from test_orc_fpd where a > 9000000 group by a % 10, length(b) % 10 </query>

    <!-- Test in set filter push down to ORC -->
    <query>select a % 10, length(b) % 10, count(1) from test_orc_fpd where a in (9000000, 1000) group by a % 10, length(b) % 10 </query>
</test>
